﻿CREATE TABLE [dbo].[Accounts]
(
[AccountID] [varchar] (10) NOT NULL,
[FirstName] [varchar] (50) NULL,
[LastName] [varchar] (50) NULL,
[Password] [varchar] (50) NOT NULL,
[Email] [varchar] (200) NOT NULL,
[AccountType] [int] NOT NULL,
[Status] [int] NOT NULL,
[LastLogin] [datetime] NULL,
[ForceChangePassword] [bit] NOT NULL,
[FailedLoginTimes] [int] NOT NULL,
[GraceLoginTimes] [int] NOT NULL,
[AgentNumber] [int] NOT NULL,
[DivisionNum] [varchar] (2) NULL,
[IsRuleEnabled] [bit] NULL,
[IsRepeatRuleEnabled] [bit] NULL
) ON [PRIMARY]


